public class kcbDB {
    public static void main(String[] args) {
        int []cno={101,102,206,208,210,209,212,301,302};
        String []cn={"计算机基础","程序设计与语言","离散数学","数据结构","计算机原理","操作系统","数据库原理","计算机网络","软件工程"};
        int []sem={1,2,4,5,5,6,7,7,7};
        int []time={80,68,68,68,85,68,68,51,51};
        int []score={5,4,4,4,5,4,4,3,3};
        System.out.println("INSERT INTO kcb VALUES");
        for (int i = 0; i < 9; i++) {
            String sql=("("+cno[i]+","+"'"+cn[i]+"',"+sem[i]+","+time[i]+","+score[i]+")");
            if(i==8)
                System.out.println(sql);
            else
                System.out.println(sql+",");
        }
    }
}
